Data Analytics and Visualization Assignment May 2021

Criterias:

Students from Department of Mathematics and Statistics (DMS) in University DAR (UDAR) study one of the following three-year Bachelor programmes:

Cost:

1) The tuition fee for every trimester is between RM3,000 - RM4,000.

2) The administration fee for each year is RM1,500 - RM2,000.

Types of Scholarship/Financial Assistantship:

1) Scholarship A

2) Scholarship B

3) Financial Assistance

A fund with total amount of RM1,000,000 is created for new students that enrol in May 2021. Hence, the new student must have completed the study of STPM/A-level/UDAR Foundation/etc before enrolling in degree courses above.

1) Pivot Table

2) Data Visualization

3) Model

4) Scholarships Fund Expense

5) Scholarship/Financial Assistance Application Form

Pivot Table for All Courses and Math Courses

Pivot Table for All Courses

1) Course

2) School

3) Family_income

4) Parent_marriage

5) Status

Pivot Table for Math Courses

1) Course

2) School

3) Family_income

4) Parent_marriage

5) Status

Data Visualization for Math Courses

ML Model for Classification

4) Expected Amount of Scholarships Funds and Financial Assistance Funds

Tuition Fee

The tuition fee for each trimester is between RM3,000 - RM4,000. The expected tuition fee for each semester is RM3,500 <<< (RM4,000+RM3,000)/2. Besides, the expected adminstration fee per year is RM1,750.

The total numbers of applicants are 104, while 50 applicants are eligible for the scholarships fund or financial assistance fund while the rest of 54 applicants were failed to meet the criterias.

There are 10 applicants will receive 100% tuition fee and admin fee waiver scholarship, 20 applicants will receive 50% tuition fee waiver scholarship and 20 applicants will receive zero-percent interest-rate student loans.

"""

I forgot to consider the total fund of RM1,000,000 only. So, if assuming each year has two long semesters, the fund is sufficient to cover 50 successful applicants. And it is the upper bound amount without considering if they fail to meet the scholarship or financial assistance minimum requirements.

"""